UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xRD+IAMhpLnFQP8gdyH2mLXPfVFyefY545BN5ckEPzg='
WHERE
key_id = 'e986a30c23fc967ee9d78b0bcb76ef82505c96de29b438ebefaa1136405419da'
AND (
token = 'xRD+IAMhpLnFQP8gdyH2mLXPfVFyefY545BN5ckEPzg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)