UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'l5gQKEwDSIY5l+yona5aNnhpoezqGLIh+6JBp/jMZgA='
WHERE
key_id = '7f5631bd03f189d0b35e07e7d8f8ee0c86179490bfdfa45f7d294bb52461dc92'
AND (
token = 'l5gQKEwDSIY5l+yona5aNnhpoezqGLIh+6JBp/jMZgA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)