UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p0bk03IaIEgOe4zyCZ69rLOI/VBDfqAHJ5BVXlX4alE='
WHERE
key_id = 'be4bd7fcb9a8dbe13d91dedc0da37c7829516654b83c1762499d8819a86ef78e'
AND (
token = 'p0bk03IaIEgOe4zyCZ69rLOI/VBDfqAHJ5BVXlX4alE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)