UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pT+HtTci8loD9L8nVTKKLyQftgRztzkS+5ZPSzgVYg0='
WHERE
key_id = 'c2b102ed14125e2da2172324697259f92fad235d142eb0065bc05aa66ac1d253'
AND (
token = 'pT+HtTci8loD9L8nVTKKLyQftgRztzkS+5ZPSzgVYg0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)