UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4hWQ0xvsMI9xhcrYvO9rOrLs5p1HGyRiy2M9SQ9y2Hw='
WHERE
key_id = '0765c6f852823a7c76217d55ce92f2eb11e0bad7e0b0bdfc0353ddadbd88dfb4'
AND (
token = '4hWQ0xvsMI9xhcrYvO9rOrLs5p1HGyRiy2M9SQ9y2Hw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)