UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4EMZjPEQlRGWRk96DicEFrnOTwwStVf/HCEJ9s3WRtk='
WHERE
key_id = 'e307617b3737a78f2594eaf9e23c04ea4fbf603f0e44c7164c27a167e2b25451'
AND (
token = '4EMZjPEQlRGWRk96DicEFrnOTwwStVf/HCEJ9s3WRtk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)