UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gT1j49EvcxjhHHcZ2VKXVJaHQfSDsMNT+AHT5Sj9eOw='
WHERE
key_id = 'bb2af72d4bc8b7d0ea9b4971e6e2ee26556b669d8f2fec038126be310183b472'
AND (
token = 'gT1j49EvcxjhHHcZ2VKXVJaHQfSDsMNT+AHT5Sj9eOw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)