UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vY/k3JH4/7ooAz7/RC4USXY3GuU9HauZGeSzQke4+W8='
WHERE
key_id = 'd276c170bf650b8424b81ee45ff67b221a7ca9f29eea612ca5aaaff1472fc960'
AND (
token = 'vY/k3JH4/7ooAz7/RC4USXY3GuU9HauZGeSzQke4+W8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)