UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0C0Pw1245PhAKczS1wF8PQbyk20Qc4JeIFBkcRZYkgw='
WHERE
key_id = '5d2d38c5f1f966ce703fc5e891c9b0e3803faadf8d110571f8767a73e44990de'
AND (
token = '0C0Pw1245PhAKczS1wF8PQbyk20Qc4JeIFBkcRZYkgw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)