UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7ZHJY1Y374YFzdf2FZQAwELllK+WJpUfWrV6vpqca7Y='
WHERE
key_id = '6ca95ec712fc237758e6239c3713f89792a05dc6134eecd33e242c6c5ee5c90a'
AND (
token = '7ZHJY1Y374YFzdf2FZQAwELllK+WJpUfWrV6vpqca7Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)