UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wggT8OcYUgMwt7qUUKIp65Y/VcD37CkwwcOFWXzsXmI='
WHERE
key_id = 'ea58356fb4c1bf28f4598ec3f06ca6bd453435f3a4669ced6def8fd53e3553cf'
AND (
token = 'wggT8OcYUgMwt7qUUKIp65Y/VcD37CkwwcOFWXzsXmI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)