UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UBB3NT86GRsV9y5EmM9S1ZSP0NVNXKAFesDeoGV7Mbg='
WHERE
key_id = 'ac93d9c5aa348dfc76a748344eb447a2f6ba800e8d135379d69f3aa5166ff8a5'
AND (
token = 'UBB3NT86GRsV9y5EmM9S1ZSP0NVNXKAFesDeoGV7Mbg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)