UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yddAzJItN90AWCTcp4BZN39ozBck5EPmbw17cjL/Kws='
WHERE
key_id = 'b5a8fcf92c99de18c100fbed415ee04508d08ae95faa812240d53a7ef593647e'
AND (
token = 'yddAzJItN90AWCTcp4BZN39ozBck5EPmbw17cjL/Kws='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)