UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AzLtONOJAF8yvhN9wHuTUym/hENI02KkS0NwCN8H878='
WHERE
key_id = '1a4b7ef866d23088a0ab3329ac66544d5d6a6ec4f90e787b2c3f3d05f678f23a'
AND (
token = 'AzLtONOJAF8yvhN9wHuTUym/hENI02KkS0NwCN8H878='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)