UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N38FaELRzlr6pa/k7wkboFJyuZklol+8diMYSDsP4vc='
WHERE
key_id = 'd5adbb5aa3334589b10ed71d35688647233823e72209ed3d166accd89fc0e95a'
AND (
token = 'N38FaELRzlr6pa/k7wkboFJyuZklol+8diMYSDsP4vc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)