UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yzdLQCoBmJNg3DztEZDSaVh65dNn9WeGWlpTSQathI0='
WHERE
key_id = '309a1af67236ca9fa191531eb151fc97df0440178119ebe2c9a5be0641c9865c'
AND (
token = 'yzdLQCoBmJNg3DztEZDSaVh65dNn9WeGWlpTSQathI0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)