UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a6eQlsSmlcu2p+k9xPb6HMI+a505sKfDc4Uc68qcbHg='
WHERE
key_id = '504357b42f8108475fbbaa059fcafd03d785cf489fa72d39e1f99aa25ba28efb'
AND (
token = 'a6eQlsSmlcu2p+k9xPb6HMI+a505sKfDc4Uc68qcbHg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)