UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'R8jNHXc9KrEUrXKwDohNyOtMdhGeWcdlTNTl1JYE3N4='
WHERE
key_id = '73618861f2e04ed67ffe5a8f5df17578e89a8a3340f3fdefb661d89f3e0a550b'
AND (
token = 'R8jNHXc9KrEUrXKwDohNyOtMdhGeWcdlTNTl1JYE3N4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)