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