UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vKMzwAifVjuuZZ2ZZEMulenmv29YKbknh2SnaIn8TFI='
WHERE
key_id = '6d24b9464f05d32ffd246c9f072763f36e1b768184fddbf7f16062535db81ac9'
AND (
token = 'vKMzwAifVjuuZZ2ZZEMulenmv29YKbknh2SnaIn8TFI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)