UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pQHMdEg57SUt4dH0A2P/wJjvK1zZmlWC/ptNVQ4mslc='
WHERE
key_id = 'eae11e438b38dc2143fa24875134cf905e1bb5f7989af0434f2bc7db979b2187'
AND (
token = 'pQHMdEg57SUt4dH0A2P/wJjvK1zZmlWC/ptNVQ4mslc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)