UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dIpjeLfqSEkGYTglDPDFk9HmfYKDPQkdImawiNrFeCI='
WHERE
key_id = '8f16ef727b5463fb7e5ef3909ebc63fa8b956b0e6a0b469d77acfda665411304'
AND (
token = 'dIpjeLfqSEkGYTglDPDFk9HmfYKDPQkdImawiNrFeCI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)