UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D78+2etiQLQ4b6PfQcOzZRjPmNEJIpefnDX0t0KsdMM='
WHERE
key_id = '4afade14a4f32e03f31342ecdbbf27967e46c3d2d518ad71c082730a6693db26'
AND (
token = 'D78+2etiQLQ4b6PfQcOzZRjPmNEJIpefnDX0t0KsdMM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)