UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QBfp7ho02zH3NtK04fWrRoUu/GRb/QIfpwU4y/TC08M='
WHERE
key_id = '07ed3287c15fe76a7ed2612a5a9425d252b12ae25910b2debb5e4ea7a12379a9'
AND (
token = 'QBfp7ho02zH3NtK04fWrRoUu/GRb/QIfpwU4y/TC08M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)