UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W/ZGG450MAyRogxCj3LF96e12lTXsmyuGe64T9d+kNA='
WHERE
key_id = '1f29339b84af8425d017af813a88369df5a49fb5933f625b3e0ed84af5a69a3a'
AND (
token = 'W/ZGG450MAyRogxCj3LF96e12lTXsmyuGe64T9d+kNA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)