UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AprTC3I4mCX+7+YjJz7uKiMDNsl8x++YxsapjHBTEGU='
WHERE
key_id = '470364eee1e667d9fecdf1e65534eebdab99ddb420e43b5eba834c75bac2a7c8'
AND (
token = 'AprTC3I4mCX+7+YjJz7uKiMDNsl8x++YxsapjHBTEGU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)