UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OgxzF7hpQJyqQFPJ1X1wBTiv+Z17nT/6C3ytG19rpk8='
WHERE
key_id = 'b0e174d68075dd78e7241e12a9e3a1e636f78f73cf8d21278edfc5bad3c9bd11'
AND (
token = 'OgxzF7hpQJyqQFPJ1X1wBTiv+Z17nT/6C3ytG19rpk8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)