UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8BstBAg3ugT96u+YdXSKrdszB+cHIw6UwtxRghR17Sc='
WHERE
key_id = 'de6d294260da9af5e5a27fbef1fcf4a772f7d8f4aa98ce84b2096f12400a083f'
AND (
token = '8BstBAg3ugT96u+YdXSKrdszB+cHIw6UwtxRghR17Sc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)