UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3Dg6lfsmo1KN/Htuml/gjKztVDBSgiywdsBD8vs9CeY='
WHERE
key_id = '91c54e80f64660078901b7d44463a886e785b751344d0c7d4a83d3b8429b9ac1'
AND (
token = '3Dg6lfsmo1KN/Htuml/gjKztVDBSgiywdsBD8vs9CeY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)