UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/zbuoZKersaFfcLCcz7KGLWSoOokPpIUfYGx3syLiC8='
WHERE
key_id = '6f2b5517a3c8063c0b366ddb95c931e13c728dd0b7f56922e65a31410177383a'
AND (
token = '/zbuoZKersaFfcLCcz7KGLWSoOokPpIUfYGx3syLiC8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)