UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'I9oLGtp47+3FPe0jqeJClrdhOtkK5LTfksHgaPfF7ks='
WHERE
key_id = 'd1dccddf41b952893313b2d2ec56fbd8757132d15e714633d90e1f06f151b7b5'
AND (
token = 'I9oLGtp47+3FPe0jqeJClrdhOtkK5LTfksHgaPfF7ks='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)