UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z+0thGrFrH0wT38aPs3F5QixkAfiF2nc0DIHpNdJ5T8='
WHERE
key_id = 'c9d2e1d3622ce2f778fb89017c8e3d56e318f2561e7121a3936d16a162057621'
AND (
token = 'Z+0thGrFrH0wT38aPs3F5QixkAfiF2nc0DIHpNdJ5T8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)