UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pGMroG1tqFgoBAV+0YoH5COJesq+9hdS7ajPU9zZpwU='
WHERE
key_id = '58db8cd42b5e2a8222ac2e8ede14be2392eca7530c0f46d085611dbda52555be'
AND (
token = 'pGMroG1tqFgoBAV+0YoH5COJesq+9hdS7ajPU9zZpwU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)