UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xHzVfAS75tRcDDd8koZO0TtHbDjvzo8jhuS5+Daico8='
WHERE
key_id = '097e696875ece348eb5ca6b08f56e271e225e9b5bbe4b7dfb03edd6dee73c857'
AND (
token = 'xHzVfAS75tRcDDd8koZO0TtHbDjvzo8jhuS5+Daico8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)