UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/Yd5U1yQXcYz2c0CuwG9V30eokkO4b3HIIbMcRTBc5E='
WHERE
key_id = 'd161720e6556812e0f08bbab6f349d42c5d7bb322d20716456eb6a38406f1f2a'
AND (
token = '/Yd5U1yQXcYz2c0CuwG9V30eokkO4b3HIIbMcRTBc5E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)